package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "user_info", simpleName = "", engine = MysqlDriver.InnoDB, comment = "用户信息")
public class _DDL_UserInfo {

    @_DDL_Primary()
    @_DDL_Column(name = "USER_ID", type = SqlType.INT, nullable = false, comment = "用户ID")
    private Integer id;

    @_DDL_Column(name = "BASE_ACC_TYPE", type = SqlType.INT, nullable = false, comment = "基础账号类型，1：平安、2：内部户")
    private Integer baseAccType;

    @_DDL_Column(name = "OPERATE_PWD", type = SqlType.VARCHAR, size = 64, comment = "")
    private String operatePwd;

    @_DDL_Column(name = "USER_NAME", type = SqlType.VARCHAR, size = 40, comment = "用户姓名")
    private String name;

    @_DDL_Column(name = "USER_PHONE", type = SqlType.VARCHAR, size = 20, comment = "用户手机号")
    private String phone;

    @_DDL_Column(name = "USER_ID_TYPE", type = SqlType.VARCHAR, size = 1, comment = "用户证件类型")
    private String idType;

    @_DDL_Column(name = "USER_ID_NO", type = SqlType.VARCHAR, size = 20, comment = "用户证件号")
    private String idNo;

    @_DDL_Column(name = "USER_BANK_CARD_NO", type = SqlType.VARCHAR, size = 30, comment = "用户银行卡号")
    private String bankCardNo;

    @_DDL_Column(name = "REGISTER_TIME", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "注册时间")
    private java.sql.Timestamp registerTime;

    @_DDL_Column(name = "UPDATE_TIME", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP_ON_UPDATE, comment = "更新时间")
    private java.sql.Timestamp updateTime;

    @_DDL_Column(name = "LOGIN_TIME", type = SqlType.TIMESTAMP, comment = "登陆时间")
    private java.sql.Timestamp loginTime;

    @_DDL_Column(name = "REFRESH_TOKEN", type = SqlType.VARCHAR, size = 32, comment = "刷新令牌")
    private String refreshToken;

    @_DDL_Column(name = "ACCESS_TOKEN", type = SqlType.VARCHAR, size = 32, comment = "访问令牌")
    private String accessToken;

    @_DDL_Column(name = "USER_NAME_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "用户姓名密文")
    private String nameCiphertext;

    @_DDL_Column(name = "USER_PHONE_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "用户手机号密文")
    private String phoneCiphertext;

    @_DDL_Column(name = "USER_ID_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "用户身份证密文")
    private String idNoCiphertext;

    @_DDL_Column(name = "USER_BANK_CARD_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "用户银行卡号密文")
    private String bankCardNoCiphertext;

    @_DDL_Index(name = "idx_AG_ID")
    @_DDL_Column(name = "AG_ID", type = SqlType.INT_UNSIGNED, comment = "")
    private Long agId;

}
